﻿CREATE TABLE [dbo].[Fabric_Tbl] (
    [FabricID]               INT            IDENTITY (1, 1) NOT NULL,
    [PartCode]               NVARCHAR (255) NULL,
    [UMLHardwareSuppliersID] INT            NULL,
    [ConstructionID]         INT            NULL,
    [GenericYarnID]          INT            NULL,
    [IsNylon]                BIT            NOT NULL,
    [FabricTypeID]           INT            NULL,
    [FabricStyleID]          INT            NULL,
    [Width]                  FLOAT          NULL,
    [Dpi]                    SMALLINT       NULL,
    [Ozsmsy]                 FLOAT          NULL,
    [Gmsqm]                  FLOAT          NULL,
    [Film]                   FLOAT          NULL,
    [Substrate]              NVARCHAR (255) NULL,
    [SingleSided]            BIT            NOT NULL,
    [TarrifCode]             NVARCHAR (255) NULL,
    [Tariff]                 FLOAT          NULL,
    [FreightFactor]          FLOAT          NULL,
    [LandedPriceDKK]         FLOAT          NULL,
    [LandedPriceEURO]        FLOAT          NULL,
    [LandedPriceGBP]         FLOAT          NULL,
    [LandedPriceUSD]         FLOAT          NULL,
    [DiscountDKK]            FLOAT          NULL,
    [DiscountEURO]           FLOAT          NULL,
    [DiscountGBP]            FLOAT          NULL,
    [DiscountUSD]            FLOAT          NULL,
    [CurExRateDKK]           FLOAT          NULL,
    [CurExRateUSD]           FLOAT          NULL,
    [CurExRateEURO]          FLOAT          NULL,
    [CurExRateGBP]           FLOAT          NULL,
    [ConStockMaxLevel]       NVARCHAR (255) NULL,
    [ConStock]               BIT            NOT NULL,
    [Warp10lb]               NVARCHAR (255) NULL,
    [Warp40lb]               FLOAT          NULL,
    [Warp50lb]               NVARCHAR (255) NULL,
    [Warp200lb]              NVARCHAR (255) NULL,
    [Fill10lb]               NVARCHAR (255) NULL,
    [Fill40lb]               FLOAT          NULL,
    [Fill50lb]               NVARCHAR (255) NULL,
    [Fill200lb]              NVARCHAR (255) NULL,
    [Bias10lb]               NVARCHAR (255) NULL,
    [Bias40lb]               FLOAT          NULL,
    [Bias50lb]               NVARCHAR (255) NULL,
    [Bias200lb]              NVARCHAR (255) NULL,
    [Elong1perc]             NVARCHAR (255) NULL,
    [CMM]                    FLOAT          NULL,
    [QuoteName]              NVARCHAR (255) NULL,
    [Quotable]               NVARCHAR (255) NULL,
    [QuoteCost]              FLOAT          NULL,
    [QuoteCostpersqm]        FLOAT          NULL,
    [SupPartCode]            NVARCHAR (255) NULL,
    [SupDes]                 NVARCHAR (255) NULL,
    [UKPrice]                NVARCHAR (255) NULL,
    [DutchPrice]             NVARCHAR (255) NULL,
    [DutchPrice97]           NVARCHAR (255) NULL,
    [Notes]                  NTEXT          NULL,
    [CutSpeed]               FLOAT          NULL,
    [FabricCurrent]          BIT            NOT NULL,
    [AlternativePrice]       NVARCHAR (255) NULL,
    [SailCostFactor]         FLOAT          NULL,
    [TrueWeight]             FLOAT          NULL,
    [Varenummer]             NVARCHAR (50)  NULL,
    [FabricArchived]         BIT            NOT NULL
);

